Grouping

Grouping lets you organize your table by one or more columns, creating expandable groups with summary rows. This feature is available in both Simple Table and Simple Table Bodied macros.

You can group by a single column, or progressively by multiple columns—for example, first by Region, then by Manager, then by Product. The result is a hierarchical table view that makes patterns easier to analyze.

When grouping is enabled, you can apply an aggregation function (like Sum or Average) to each column to determine how grouped data is summarized. These results appear in the group row, replacing cell values that would otherwise be unclear at that aggregation level.

For example, if you group by Date and aggregate the Total column using Sum, each group row will show the sum of all rows inside that date group in the same row where the group label appears.

Any other columns that are not grouped or aggregated are hidden in the group summary row to avoid showing unrelated or misleading data.

Grouping must first be enabled from the Display tab. Once enabled, you can configure how each column is aggregated from the Columns tab.